github.com/readium/readium-lcp-server@v0.0.0-20240509124024-799e77a0bbd6/dbmodel/sqlite _db_setup_frontend.sql (about)

     1  CREATE TABLE publication (
     2    id integer NOT NULL PRIMARY KEY,
     3    uuid varchar(255) NOT NULL,
     4    title varchar(255) NOT NULL,
     5    status varchar(255) NOT NULL
     6  );
     7  
     8  CREATE INDEX uuid_index ON publication (uuid);
     9  
    10  CREATE TABLE purchase (
    11    id integer NOT NULL PRIMARY KEY,
    12    uuid varchar(255) NOT NULL,
    13    publication_id integer NOT NULL,
    14    user_id integer NOT NULL,
    15    license_uuid varchar(255) NULL,
    16    "type" varchar(32) NOT NULL,
    17    transaction_date datetime,
    18    start_date datetime,
    19    end_date datetime,
    20    status varchar(255) NOT NULL,
    21    FOREIGN KEY (publication_id) REFERENCES publication(id),
    22    FOREIGN KEY (user_id) REFERENCES "user"(id)
    23  );
    24    
    25  CREATE INDEX idx_purchase ON purchase (license_uuid);
    26  
    27  CREATE TABLE "user" (
    28    id integer NOT NULL PRIMARY KEY,
    29    uuid varchar(255) NOT NULL,
    30    name varchar(64) NOT NULL,
    31    email varchar(64) NOT NULL,
    32    password varchar(64) NOT NULL,
    33    hint varchar(64) NOT NULL
    34  );
    35  
    36  CREATE TABLE license_view (
    37    id integer NOT NULL PRIMARY KEY,
    38    uuid varchar(255) NOT NULL,
    39    device_count integer NOT NULL,
    40    status varchar(255) NOT NULL,
    41    message varchar(255) NOT NULL
    42  );